Creating Retrieve Only Top/Bottom Definitions

  To create a Retrieve Only Top/Bottom definition:

  1. Right-click a member, and select Analysis Tools , then Retrieve Only Top/Bottom.

    The Retrieve Only Top/Bottom dialog box is displayed.

  2. From Column, select the column to which the Retrieve Only Top/Bottom definition.

  3. Limit the result set by selecting Top or Bottom and, in the relevant box, indicating the number of members.

  4. Sort the result set by selecting Ascending or Descending.

  5. Optional: To remove all selections from the current definition and start over, click Clear.

  6. Click OK.